速報APP / 教育 / Learn H2 Database

Learn H2 Database

價格:免費

更新日期:2019-06-12

檔案大小:3.9M

目前版本:1.0

版本需求:Android 4.0 以上版本

官方網站:mailto:dongchinhlazare@gmail.com

Email:https://educationalappz.blogspot.com/2019/03/educational-appz-privacy-policy.html

Learn H2 Database(圖1)-速報App

Learn H2 Database, Basic H2 Database, H2 Database book, H2 Database app, learn basic H2 Database, H2 Database notes, H2 Database tutorial.

Learn H2 Database(圖2)-速報App

H2 is a relational database management system written in Java. It can be embedded in Java applications or run in client-server mode. The software is available as open source software Mozilla Public License 2.0 or the original Eclipse Public License.

Learn H2 Database(圖3)-速報App

A subset of the SQL (Structured Query Language) standard is supported. The main programming APIs are SQL and JDBC, however the database also supports using the PostgreSQL ODBC driver by acting like a PostgreSQL server.

It is possible to create both in-memory tables, as well as disk-based tables. Tables can be persistent or temporary. Index types are hash table and tree for in-memory tables, and b-tree for disk-based tables. All data manipulation operations are transactional. Table level locking and multiversion concurrency control are implemented. The 2-phase commit protocol is supported as well, but no standard API for distributed transactions is implemented. The security features of the database are: role based access rights, encryption of the password using SHA-256 and data using the AES or the Tiny Encryption Algorithm, XTEA. The cryptographic features are available as functions inside the database as well. SSL / TLS connections are supported in the client-server mode, as well as when using the console application.